﻿/*****************************************************************************/
/*****************************************************************************/
CREATE PROCEDURE [CaseManagement].[CasesForServiceMember]( @ServiceManID BIGINT )
AS  
BEGIN

	Select  Cases.OID as 'CaseOID', 
			Cases.Version as 'CaseVersion', 
			Cases.ServiceManID, 
			Cases.CaseVolunteerID,
			Cases.CaseDirectorID,
			Cases.InjuryDate,

			Users.OID as 'UsersOID', 
			Users.GUID, 
			Users.FullName, 
			Users.UPN, 
			Users.LastSignedIn

	From Cases
	Join Users On Users.OID = Cases.CaseVolunteerID
	Where
		Cases.ServiceManID = @ServiceManID

END


